package com.smartwebx.ha.dal.realtime.dao;

import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.smartwebx.ha.dal.config.OracleConfigInfo;
import com.smartwebx.ha.dal.inter.water.HDAndBDGCProcessDataOperatDao;
import com.smartwebx.ha.dal.usebean.DateValue;

public interface RvsectMapper extends HDAndBDGCProcessDataOperatDao{
	String ST_RVSECT_B = OracleConfigInfo.REALTIME_NAME + ".ST_RVSECT_B";
	
	/**
	 * 获得单站日河底高程过程（取每日8时数据）
	 * 
	 * @param stcd
	 * @param startDate
	 * @param endDate
	 * @return
	 */
	@Select("SELECT MSTM,ZB val FROM " 
			+ ST_RVSECT_B
			+ " WHERE STCD=#{stcd} AND MSTM>=#{startDate} AND MSTM<#{endDate} AND to_char(MSTM,'HH24')=8")
	public List<DateValue> getSingleStatDayHDGCProcess(@Param("stcd") String stcd,
			@Param("startDate") Date startDate, @Param("endDate") Date endDate);

}
